clear
cd "\\file\Userss$\sho88\Home\Desktop\World Development\FinalCodes\"
import excel "CodingData.xlsx", sheet("Sheet1") firstrow case(lower)
drop if _n > 676
mdesc
gen pcc = tstat1/(sqrt(tstat1^2+df))
gen sepcc = sqrt((1-pcc^2)/df)
rename cs crosssection
rename variabletype1 busenviron
keep id pcc sepcc fdigdp fdilog fdiother entretype1 entretype2 entretype3 entreother oecd nonoecd mixedcountry /// 
crosssection panelfe panelnofe iv lagdv english journal notjournal pubyear tstat1 df busenviron
export delimited using "\\file\Userss$\sho88\Home\Desktop\World Development\FinalCodes\data_sorted.csv", replace
